create procedure [dbo].[BAEImisSecurityGroupsInsert] @SECURITY_GROUP as
varchar(255),
    @SECURITY_GROUP_DESCR AS varchar(255),
    @WEBKITENABLED    AS     bit,
    @ADHOCENABLED    AS     bit,
    @MEMBERSHIPLEVEL    AS     bit,
    @MEETINGSLEVEL    AS     bit,
    @SYSTEMLEVEL    AS     bit,
    @DUESLEVEL    AS     bit,
    @CASHARLEVEL    AS     bit,
    @ORDERENTRYLEVEL    AS     bit,
    @REFERRALLEVEL    AS     bit,
    @CERTLEVEL    AS     bit,
    @FRLEVEL    AS     bit,
    @SECURITY_SEQ    AS     tinyint,
    @COMMUNITIESLEVEL    AS     bit
AS
    INSERT INTO Security_Groups
    (
    SECURITY_GROUP,
    SECURITY_GROUP_DESCR,
    WEBKITENABLED,
    ADHOCENABLED,
    MEMBERSHIPLEVEL,
    MEETINGSLEVEL,
    SYSTEMLEVEL,
    DUESLEVEL,
    CASHARLEVEL,
    ORDERENTRYLEVEL,
    REFERRALLEVEL,
    CERTLEVEL,
    FRLEVEL,
    SECURITY_SEQ,
    COMMUNITIESLEVEL)
    VALUES (
    @SECURITY_GROUP,
    @SECURITY_GROUP_DESCR,
    @WEBKITENABLED,
    @ADHOCENABLED,
    @MEMBERSHIPLEVEL,
    @MEETINGSLEVEL,    
    @SYSTEMLEVEL,    
    @DUESLEVEL,    
    @CASHARLEVEL,    
    @ORDERENTRYLEVEL,    
    @REFERRALLEVEL,    
    @CERTLEVEL,    
    @FRLEVEL,
    @SECURITY_SEQ,
    @COMMUNITIESLEVEL
);

GO